Excel 2019 for Business Statistics by Thomas J. Quirk

Excel 2019 for Business Statistics by Thomas J. Quirk

Author:Thomas J. Quirk
Language: eng
Format: epub
ISBN: 9783030392611
Publisher: Springer International Publishing


B8:  Null hypothesis:

B10: Research hypothesis:

Since both groups have a sample size greater than 30, you need to use Formula #1 for the t-test for the difference of the means of the two groups.

Let’s “break this formula down into pieces” to reduce the chance of making a mistake.

B13:  STDEV1 squared/n1 (note that you square the standard deviation of Group 1, and then divide the result by the sample size of Group 1)

B16:  STDEV2 squared/n2

B19:  D13 + D16

B22:  s.e.

B25:  critical t

B28:  t-test

B31:  Result:

B36:  Conclusion: (see Fig. 5.10)

Fig. 5.10Formula Labels for the Two-group t-test



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.